A server trigger can be a DDL or logon trigger for current server. DDL triggers execute in response to a variety of data definition language (DDL) events. These events primarily correspond to Transact-SQL CREATE, ALTER, and DROP statements, and certain system stored procedures that perform DDL-like operations. Logon triggers fire in response to the LOGON event that is raised when a user sessions is being established.
Note: Support from SQL Server 2005 or later.
Just simply click ->
Server Trigger to open
an object pane for Server Trigger. A control-click displays the
popup menu or using the object pane toolbar below, allowing you to create
new, edit and delete the selected server trigger.
Create Server Trigger
To create a new server trigger
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Server Trigger from the popup menu.
- Edit server trigger properties on the appropriate tabs of the Server Trigger Designer.
To create a new server trigger with modification as one of the existing server trigger
- Select the server trigger for modifying in the object pane.
- Control-click and select the Design
Server Trigger from the popup menu or simply double-click the server trigger.
or - Click the
from the object pane toolbar.
- Modify server trigger properties on the appropriate tabs of the Server Trigger Designer.
- Click
Save As.
To edit the existing server trigger(manage its general etc)
- Select the server trigger for editing in the object pane.
- Control-click and select the Design
Server Trigger from the popup menu or simply double-click the server trigger.
or - Click the
from the object pane toolbar.
- Edit server trigger properties on the appropriate tabs of the Server Trigger Designer.
Maintain Server Trigger
To maintain a server trigger
- Select the server trigger for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Enable Trigger
- Disable Trigger
Delete Server Trigger
To delete a server trigger
- Select the server trigger for deleting in the object pane.
- Control-click and select the Delete Server Trigger
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Server Trigger Information
To achieve a server trigger information
- Select the server trigger in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.